Failed
Scenario: DV1 Data view publish to CTRL_ACC_REPLY.Given Mqtt Device is started (from org.eclipse.kapua.service.device.integration.RunBrokerACLI9nTest)
Failing for the past 9 builds
(Since Unstable
)
Error Message
An internal error occurred: org.apache.shiro.ShiroException: Error while find user!.
Stacktrace
org.eclipse.kapua.KapuaException: An internal error occurred: org.apache.shiro.ShiroException: Error while find user!. Caused by: org.apache.shiro.authc.AuthenticationException: org.apache.shiro.ShiroException: Error while find user! Caused by: org.apache.shiro.ShiroException: Error while find user! Caused by: org.eclipse.kapua.KapuaException: An internal error occurred: Error during Persistence Operation. Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160428-59c81c5): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*] b "; SQL statement: SET MODE MySQL://localhost:3306/kapuadb [42000-192] Error Code: 42000 Caused by: org.eclipse.persistence.exceptions.DatabaseException: Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*] b "; SQL statement: SET MODE MySQL://localhost:3306/kapuadb [42000-192] Error Code: 42000 Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*] b "; SQL statement: SET MODE MySQL://localhost:3306/kapuadb [42000-192]
Standard Output
05:09:38.115 [main] INFO o.e.k.s.user.steps.UserServiceSteps - Logging out in cleanup 05:09:38.115 [main] INFO o.e.k.c.c.KapuaConfigurableServiceSchemaUtilsWithResources - Running database script from resources... 05:09:38.116 [main] INFO o.e.k.c.jpa.SimpleSqlScriptExecutor - Running resources script: database/all_delete.sql 05:09:38.118 [main] INFO o.e.k.c.c.KapuaConfigurableServiceSchemaUtilsWithResources - ...database scripts from resources done! 05:09:38.118 [main] INFO o.e.k.c.c.KapuaConfigurableServiceSchemaUtilsWithResources - Running database script from resources... 05:09:38.119 [main] INFO o.e.k.c.jpa.SimpleSqlScriptExecutor - Running resources script: database/all_delete.sql 05:09:38.120 [main] INFO o.e.k.c.c.KapuaConfigurableServiceSchemaUtilsWithResources - ...database scripts from resources done! 05:09:38.121 [main] INFO o.eclipse.kapua.qa.steps.BasicSteps - Wait multiplier active: 4.0 05:09:38.121 [main] INFO org.eclipse.kapua.qa.steps.DBHelper - Setting up mock database 05:09:38.138 [main] INFO org.reflections.Reflections - Reflections took 5 ms to scan 12 urls, producing 839 keys and 852 values 05:09:38.302 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Executing pre master files... 05:09:38.302 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Master Liquibase files found: 3 05:09:38.302 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-authorization-master.pre.xml 05:09:38.325 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-event-store-master.pre.xml 05:09:38.342 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-system-configurations-master.pre.xml 05:09:38.361 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Executing pre master files... DONE! 05:09:38.361 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Executing master files... 05:09:38.361 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Master Liquibase files found: 10 05:09:38.361 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-account-master.xml 05:09:38.401 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-authentication-master.xml 05:09:38.452 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-authorization-master.xml 05:09:38.563 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-broker-master.xml 05:09:38.578 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-datastore-master.xml 05:09:38.595 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-device-management-master.xml 05:09:38.615 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-device-master.xml 05:09:38.706 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-stream-master.xml 05:09:38.718 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-tag-master.xml 05:09:38.743 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-user-master.xml 05:09:38.778 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Executing master files... DONE! 05:09:38.778 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Executing post master files... 05:09:38.778 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Master Liquibase files found: 0 05:09:38.778 [main] INFO o.e.k.s.l.KapuaLiquibaseClient - Executing post master files... DONE! # Scenario: D12 Device create sub-topic on ACL_CTRL_ACC_NOTIFY is not allowed # Normal user with device manage profile publishes to topic $EDC.{0}.*.*.NOTIFY.{1}.foo # This means that foo topic is not created as broker has no admin rights on this topic. # Given Mqtt Device is started # And device account and user are created # When broker with clientId "client-1" and user "luise" and password "kapua-password" is listening on topic "" # And string "Hello broker" is published to topic "$EDC/acme/foo/bar/NOTIFY/client-1/foo" with client "client-1" # And 1 second passed for message to arrive # Then Broker doesn't receive string "Hello broker" on topic "$EDC/acme/foo/bar/NOTIFY/client-1/foo" # And clients are disconnected # And Mqtt Device is stoped Scenario: D13 Device subscribe on ACL_CTRL_ACC_NOTIFY is not allowed # features/broker/acl/BrokerACLI9n.feature:388 Normal user with device manage profile subscribes to $EDC.{0}.*.*.NOTIFY.{1}.> Subscribe is not allowed. Given Mqtt Device is started # AclSteps.startMqttDevice() org.eclipse.kapua.KapuaException: An internal error occurred: org.apache.shiro.ShiroException: Error while find user!. at org.eclipse.kapua.KapuaException.internalError(KapuaException.java:138) at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.handleTokenLoginException(AuthenticationServiceShiroImpl.java:358) at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.login(AuthenticationServiceShiroImpl.java:154) at org.eclipse.kapua.service.device.steps.AclSteps.startMqttDevice(AclSteps.java:146) at ✽.Given Mqtt Device is started(features/broker/acl/BrokerACLI9n.feature:391) Caused by: org.apache.shiro.authc.AuthenticationException: org.apache.shiro.ShiroException: Error while find user! at org.eclipse.kapua.service.authentication.shiro.KapuaAuthenticator.doMultiRealmAuthentication(KapuaAuthenticator.java:85) at org.apache.shiro.authc.pam.ModularRealmAuthenticator.doAuthenticate(ModularRealmAuthenticator.java:269) at org.apache.shiro.authc.AbstractAuthenticator.authenticate(AbstractAuthenticator.java:198) at org.apache.shiro.mgt.AuthenticatingSecurityManager.authenticate(AuthenticatingSecurityManager.java:106) at org.apache.shiro.mgt.DefaultSecurityManager.login(DefaultSecurityManager.java:270) at org.apache.shiro.subject.support.DelegatingSubject.login(DelegatingSubject.java:256) at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.login(AuthenticationServiceShiroImpl.java:138) at org.eclipse.kapua.service.device.steps.AclSteps.startMqttDevice(AclSteps.java:146) at sun.reflect.GeneratedMethodAccessor364.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at cucumber.runtime.Utils$1.call(Utils.java:37) at cucumber.runtime.Timeout.timeout(Timeout.java:13) at cucumber.runtime.Utils.invoke(Utils.java:31) at cucumber.runtime.java.JavaStepDefinition.execute(JavaStepDefinition.java:38) at cucumber.runtime.StepDefinitionMatch.runStep(StepDefinitionMatch.java:37) at cucumber.runtime.Runtime.runStep(Runtime.java:299) at cucumber.runtime.model.StepContainer.runStep(StepContainer.java:44) at cucumber.runtime.model.StepContainer.runSteps(StepContainer.java:39) at cucumber.runtime.model.CucumberScenario.run(CucumberScenario.java:44) at cucumber.runtime.junit.ExecutionUnitRunner.run(ExecutionUnitRunner.java:91) at cucumber.runtime.junit.FeatureRunner.runChild(FeatureRunner.java:63) at cucumber.runtime.junit.FeatureRunner.runChild(FeatureRunner.java:18) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229) at org.junit.runners.ParentRunner.run(ParentRunner.java:309) at cucumber.runtime.junit.FeatureRunner.run(FeatureRunner.java:70) at cucumber.api.junit.Cucumber.runChild(Cucumber.java:93) at cucumber.api.junit.Cucumber.runChild(Cucumber.java:37) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229) at org.junit.runners.ParentRunner.run(ParentRunner.java:309) at cucumber.api.junit.Cucumber.run(Cucumber.java:98) at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365) at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:272) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:236) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159) at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:386) at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:323) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:143) Caused by: org.apache.shiro.ShiroException: Error while find user! at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.doGetAuthenticationInfo(UserPassAuthenticatingRealm.java:103) at org.apache.shiro.realm.AuthenticatingRealm.getAuthenticationInfo(AuthenticatingRealm.java:568) at org.eclipse.kapua.service.authentication.shiro.KapuaAuthenticator.doMultiRealmAuthentication(KapuaAuthenticator.java:58) ... 45 more Caused by: org.eclipse.kapua.KapuaException: An internal error occurred: Error during Persistence Operation. at org.eclipse.kapua.KapuaException.internalError(KapuaException.java:123) at org.eclipse.kapua.commons.util.KapuaExceptionUtils.convertPersistenceException(KapuaExceptionUtils.java:113) at org.eclipse.kapua.commons.jpa.EntityManagerSession.internalOnResult(EntityManagerSession.java:152) at org.eclipse.kapua.commons.jpa.EntityManagerSession.onResult(EntityManagerSession.java:118) at org.eclipse.kapua.service.user.internal.UserServiceImpl.findByName(UserServiceImpl.java:228) at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.lambda$doGetAuthenticationInfo$0(UserPassAuthenticatingRealm.java:99) at org.eclipse.kapua.commons.security.KapuaSecurityUtils.doPrivileged(KapuaSecurityUtils.java:110) at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.doGetAuthenticationInfo(UserPassAuthenticatingRealm.java:99) ... 47 more Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160428-59c81c5): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*] b "; SQL statement: SET MODE MySQL://localhost:3306/kapuadb [42000-192] Error Code: 42000 at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:815) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303) at org.eclipse.kapua.commons.jpa.AbstractEntityManagerFactory.createEntityManager(AbstractEntityManagerFactory.java:96) at org.eclipse.kapua.commons.jpa.EntityManagerSession.internalOnResult(EntityManagerSession.java:138) ... 52 more Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160428-59c81c5): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*] b "; SQL statement: SET MODE MySQL://localhost:3306/kapuadb [42000-192] Error Code: 42000 at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:326) at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:138) at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.setOrDetectDatasource(DatabaseSessionImpl.java:207) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:760) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:265) at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:731) ... 58 more Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*] b "; SQL statement: SET MODE MySQL://localhost:3306/kapuadb [42000-192] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:179) at org.h2.message.DbException.get(DbException.java:155) at org.h2.message.DbException.getSyntaxError(DbException.java:191) at org.h2.command.Parser.getSyntaxError(Parser.java:530) at org.h2.command.Parser.prepareCommand(Parser.java:257) at org.h2.engine.Session.prepareLocal(Session.java:560) at org.h2.engine.Session.prepareCommand(Session.java:501) at org.h2.engine.Engine.openSession(Engine.java:203) at org.h2.engine.Engine.createSessionAndValidate(Engine.java:154) at org.h2.engine.Engine.createSession(Engine.java:137) at org.h2.engine.Engine.createSession(Engine.java:27) at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:349) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:118) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:102) at org.h2.Driver.connect(Driver.java:72) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:208) at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:98) ... 63 more And device account and user are created # AclSteps.createDeviceAccountAndUser() Given I expect the exception "MqttException" with the text "*" # BasicSteps.setExpectedExceptionDetails(String,String) When broker with clientId "client-1" and user "luise" and password "kapua-password" is listening on topic "$EDC/acme/foo/bar/NOTIFY/client-1" # AclSteps.connectClientToBroker(String,String,String,String) 05:09:38.785 [ActiveMQ NIO Worker 0] INFO o.e.k.b.c.p.KapuaSecurityBrokerFilter - User name kapua-sys - client id: ListenerClient, connection id: ID:hipp9-55172-1539075991412-5:57 05:09:38.786 [ActiveMQ NIO Worker 0] INFO eclipselink.logging.all - EclipseLink, version: Eclipse Persistence Services - 2.6.3.v20160428-59c81c5 05:09:38.787 [ActiveMQ NIO Worker 0] ERROR eclipselink.logging.ejb - Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160428-59c81c5): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*] b "; SQL statement: SET MODE MySQL://localhost:3306/kapuadb [42000-192] Error Code: 42000 05:09:38.788 [ActiveMQ NIO Worker 0] INFO o.e.k.b.c.p.KapuaSecurityBrokerFilter - @@ error org.eclipse.kapua.KapuaException: An internal error occurred: org.apache.shiro.ShiroException: Error while find user!. at org.eclipse.kapua.KapuaException.internalError(KapuaException.java:138) at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.handleTokenLoginException(AuthenticationServiceShiroImpl.java:358) at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.login(AuthenticationServiceShiroImpl.java:154) at org.eclipse.kapua.broker.core.plugin.KapuaSecurityBrokerFilter.addExternalConnection(KapuaSecurityBrokerFilter.java:412) at org.eclipse.kapua.broker.core.plugin.KapuaSecurityBrokerFilter.addConnection(KapuaSecurityBrokerFilter.java:395) at org.apache.activemq.broker.BrokerFilter.addConnection(BrokerFilter.java:98) at org.apache.activemq.broker.MutableBrokerFilter.addConnection(MutableBrokerFilter.java:103) at org.apache.activemq.broker.TransportConnection.processAddConnection(TransportConnection.java:852) at org.apache.activemq.command.ConnectionInfo.visit(ConnectionInfo.java:139) at org.apache.activemq.broker.TransportConnection.service(TransportConnection.java:336) at org.apache.activemq.broker.TransportConnection$1.onCommand(TransportConnection.java:200) at org.apache.activemq.transport.MutexTransport.onCommand(MutexTransport.java:45) at org.apache.activemq.transport.mqtt.MQTTInactivityMonitor.onCommand(MQTTInactivityMonitor.java:162) at org.apache.activemq.transport.mqtt.MQTTTransportFilter.sendToActiveMQ(MQTTTransportFilter.java:106) at org.apache.activemq.transport.mqtt.MQTTProtocolConverter.sendToActiveMQ(MQTTProtocolConverter.java:181) at org.apache.activemq.transport.mqtt.MQTTProtocolConverter.onMQTTConnect(MQTTProtocolConverter.java:310) at org.apache.activemq.transport.mqtt.MQTTProtocolConverter.onMQTTCommand(MQTTProtocolConverter.java:205) at org.apache.activemq.transport.mqtt.MQTTTransportFilter.onCommand(MQTTTransportFilter.java:94) at org.apache.activemq.transport.TransportSupport.doConsume(TransportSupport.java:83) at org.apache.activemq.transport.mqtt.MQTTCodec$1.onFrame(MQTTCodec.java:65) at org.apache.activemq.transport.mqtt.MQTTCodec.processCommand(MQTTCodec.java:90) at org.apache.activemq.transport.mqtt.MQTTCodec.access$400(MQTTCodec.java:26) at org.apache.activemq.transport.mqtt.MQTTCodec$4.parse(MQTTCodec.java:213) at org.apache.activemq.transport.mqtt.MQTTCodec$3.parse(MQTTCodec.java:179) at org.apache.activemq.transport.mqtt.MQTTCodec$2.parse(MQTTCodec.java:138) at org.apache.activemq.transport.mqtt.MQTTCodec.parse(MQTTCodec.java:76) at org.apache.activemq.transport.mqtt.MQTTNIOTransport.processBuffer(MQTTNIOTransport.java:132) at org.apache.activemq.transport.mqtt.MQTTNIOTransport.serviceRead(MQTTNIOTransport.java:120) at org.apache.activemq.transport.mqtt.MQTTNIOTransport.access$000(MQTTNIOTransport.java:43) at org.apache.activemq.transport.mqtt.MQTTNIOTransport$1.onSelect(MQTTNIOTransport.java:72) at org.apache.activemq.transport.nio.SelectorSelection.onSelect(SelectorSelection.java:98) at org.apache.activemq.transport.nio.SelectorWorker$1.run(SelectorWorker.java:118) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: org.apache.shiro.authc.AuthenticationException: org.apache.shiro.ShiroException: Error while find user! at org.eclipse.kapua.service.authentication.shiro.KapuaAuthenticator.doMultiRealmAuthentication(KapuaAuthenticator.java:85) at org.apache.shiro.authc.pam.ModularRealmAuthenticator.doAuthenticate(ModularRealmAuthenticator.java:269) at org.apache.shiro.authc.AbstractAuthenticator.authenticate(AbstractAuthenticator.java:198) at org.apache.shiro.mgt.AuthenticatingSecurityManager.authenticate(AuthenticatingSecurityManager.java:106) at org.apache.shiro.mgt.DefaultSecurityManager.login(DefaultSecurityManager.java:270) at org.apache.shiro.subject.support.DelegatingSubject.login(DelegatingSubject.java:256) at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.login(AuthenticationServiceShiroImpl.java:138) ... 32 common frames omitted Caused by: org.apache.shiro.ShiroException: Error while find user! at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.doGetAuthenticationInfo(UserPassAuthenticatingRealm.java:103) at org.apache.shiro.realm.AuthenticatingRealm.getAuthenticationInfo(AuthenticatingRealm.java:568) at org.eclipse.kapua.service.authentication.shiro.KapuaAuthenticator.doMultiRealmAuthentication(KapuaAuthenticator.java:58) ... 38 common frames omitted Caused by: org.eclipse.kapua.KapuaException: An internal error occurred: Error during Persistence Operation. at org.eclipse.kapua.KapuaException.internalError(KapuaException.java:123) at org.eclipse.kapua.commons.util.KapuaExceptionUtils.convertPersistenceException(KapuaExceptionUtils.java:113) at org.eclipse.kapua.commons.jpa.EntityManagerSession.internalOnResult(EntityManagerSession.java:152) at org.eclipse.kapua.commons.jpa.EntityManagerSession.onResult(EntityManagerSession.java:118) at org.eclipse.kapua.service.user.internal.UserServiceImpl.findByName(UserServiceImpl.java:228) at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.lambda$doGetAuthenticationInfo$0(UserPassAuthenticatingRealm.java:99) at org.eclipse.kapua.commons.security.KapuaSecurityUtils.doPrivileged(KapuaSecurityUtils.java:110) at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.doGetAuthenticationInfo(UserPassAuthenticatingRealm.java:99) ... 40 common frames omitted Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160428-59c81c5): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*] b "; SQL statement: SET MODE MySQL://localhost:3306/kapuadb [42000-192] Error Code: 42000 at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:815) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303) at org.eclipse.kapua.commons.jpa.AbstractEntityManagerFactory.createEntityManager(AbstractEntityManagerFactory.java:96) at org.eclipse.kapua.commons.jpa.EntityManagerSession.internalOnResult(EntityManagerSession.java:138) ... 45 common frames omitted Caused by: org.eclipse.persistence.exceptions.DatabaseException: Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*] b "; SQL statement: SET MODE MySQL://localhost:3306/kapuadb [42000-192] Error Code: 42000 at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:326) at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:138) at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.setOrDetectDatasource(DatabaseSessionImpl.java:207) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:760) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:265) at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:731) ... 51 common frames omitted Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*] b "; SQL statement: SET MODE MySQL://localhost:3306/kapuadb [42000-192] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:179) at org.h2.message.DbException.get(DbException.java:155) at org.h2.message.DbException.getSyntaxError(DbException.java:191) at org.h2.command.Parser.getSyntaxError(Parser.java:530) at org.h2.command.Parser.prepareCommand(Parser.java:257) at org.h2.engine.Session.prepareLocal(Session.java:560) at org.h2.engine.Session.prepareCommand(Session.java:501) at org.h2.engine.Engine.openSession(Engine.java:203) at org.h2.engine.Engine.createSessionAndValidate(Engine.java:154) at org.h2.engine.Engine.createSession(Engine.java:137) at org.h2.engine.Engine.createSession(Engine.java:27) at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:349) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:118) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:102) at org.h2.Driver.connect(Driver.java:72) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:208) at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:98) ... 56 common frames omitted 05:09:38.789 [ActiveMQ NIO Worker 0] WARN o.a.a.broker.TransportConnection - Failed to add Connection id=ID:hipp9-55172-1539075991412-5:57, clientId=ListenerClient due to {} org.eclipse.kapua.KapuaException: An internal error occurred: org.apache.shiro.ShiroException: Error while find user!. at org.eclipse.kapua.KapuaException.internalError(KapuaException.java:138) at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.handleTokenLoginException(AuthenticationServiceShiroImpl.java:358) at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.login(AuthenticationServiceShiroImpl.java:154) at org.eclipse.kapua.broker.core.plugin.KapuaSecurityBrokerFilter.addExternalConnection(KapuaSecurityBrokerFilter.java:412) at org.eclipse.kapua.broker.core.plugin.KapuaSecurityBrokerFilter.addConnection(KapuaSecurityBrokerFilter.java:395) at org.apache.activemq.broker.BrokerFilter.addConnection(BrokerFilter.java:98) at org.apache.activemq.broker.MutableBrokerFilter.addConnection(MutableBrokerFilter.java:103) at org.apache.activemq.broker.TransportConnection.processAddConnection(TransportConnection.java:852) at org.apache.activemq.command.ConnectionInfo.visit(ConnectionInfo.java:139) at org.apache.activemq.broker.TransportConnection.service(TransportConnection.java:336) at org.apache.activemq.broker.TransportConnection$1.onCommand(TransportConnection.java:200) at org.apache.activemq.transport.MutexTransport.onCommand(MutexTransport.java:45) at org.apache.activemq.transport.mqtt.MQTTInactivityMonitor.onCommand(MQTTInactivityMonitor.java:162) at org.apache.activemq.transport.mqtt.MQTTTransportFilter.sendToActiveMQ(MQTTTransportFilter.java:106) at org.apache.activemq.transport.mqtt.MQTTProtocolConverter.sendToActiveMQ(MQTTProtocolConverter.java:181) at org.apache.activemq.transport.mqtt.MQTTProtocolConverter.onMQTTConnect(MQTTProtocolConverter.java:310) at org.apache.activemq.transport.mqtt.MQTTProtocolConverter.onMQTTCommand(MQTTProtocolConverter.java:205) at org.apache.activemq.transport.mqtt.MQTTTransportFilter.onCommand(MQTTTransportFilter.java:94) at org.apache.activemq.transport.TransportSupport.doConsume(TransportSupport.java:83) at org.apache.activemq.transport.mqtt.MQTTCodec$1.onFrame(MQTTCodec.java:65) at org.apache.activemq.transport.mqtt.MQTTCodec.processCommand(MQTTCodec.java:90) at org.apache.activemq.transport.mqtt.MQTTCodec.access$400(MQTTCodec.java:26) at org.apache.activemq.transport.mqtt.MQTTCodec$4.parse(MQTTCodec.java:213) at org.apache.activemq.transport.mqtt.MQTTCodec$3.parse(MQTTCodec.java:179) at org.apache.activemq.transport.mqtt.MQTTCodec$2.parse(MQTTCodec.java:138) at org.apache.activemq.transport.mqtt.MQTTCodec.parse(MQTTCodec.java:76) at org.apache.activemq.transport.mqtt.MQTTNIOTransport.processBuffer(MQTTNIOTransport.java:132) at org.apache.activemq.transport.mqtt.MQTTNIOTransport.serviceRead(MQTTNIOTransport.java:120) at org.apache.activemq.transport.mqtt.MQTTNIOTransport.access$000(MQTTNIOTransport.java:43) at org.apache.activemq.transport.mqtt.MQTTNIOTransport$1.onSelect(MQTTNIOTransport.java:72) at org.apache.activemq.transport.nio.SelectorSelection.onSelect(SelectorSelection.java:98) at org.apache.activemq.transport.nio.SelectorWorker$1.run(SelectorWorker.java:118) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: org.apache.shiro.authc.AuthenticationException: org.apache.shiro.ShiroException: Error while find user! at org.eclipse.kapua.service.authentication.shiro.KapuaAuthenticator.doMultiRealmAuthentication(KapuaAuthenticator.java:85) at org.apache.shiro.authc.pam.ModularRealmAuthenticator.doAuthenticate(ModularRealmAuthenticator.java:269) at org.apache.shiro.authc.AbstractAuthenticator.authenticate(AbstractAuthenticator.java:198) at org.apache.shiro.mgt.AuthenticatingSecurityManager.authenticate(AuthenticatingSecurityManager.java:106) at org.apache.shiro.mgt.DefaultSecurityManager.login(DefaultSecurityManager.java:270) at org.apache.shiro.subject.support.DelegatingSubject.login(DelegatingSubject.java:256) at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.login(AuthenticationServiceShiroImpl.java:138) ... 32 common frames omitted Caused by: org.apache.shiro.ShiroException: Error while find user! at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.doGetAuthenticationInfo(UserPassAuthenticatingRealm.java:103) at org.apache.shiro.realm.AuthenticatingRealm.getAuthenticationInfo(AuthenticatingRealm.java:568) at org.eclipse.kapua.service.authentication.shiro.KapuaAuthenticator.doMultiRealmAuthentication(KapuaAuthenticator.java:58) ... 38 common frames omitted Caused by: org.eclipse.kapua.KapuaException: An internal error occurred: Error during Persistence Operation. at org.eclipse.kapua.KapuaException.internalError(KapuaException.java:123) at org.eclipse.kapua.commons.util.KapuaExceptionUtils.convertPersistenceException(KapuaExceptionUtils.java:113) at org.eclipse.kapua.commons.jpa.EntityManagerSession.internalOnResult(EntityManagerSession.java:152) at org.eclipse.kapua.commons.jpa.EntityManagerSession.onResult(EntityManagerSession.java:118) at org.eclipse.kapua.service.user.internal.UserServiceImpl.findByName(UserServiceImpl.java:228) at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.lambda$doGetAuthenticationInfo$0(UserPassAuthenticatingRealm.java:99) at org.eclipse.kapua.commons.security.KapuaSecurityUtils.doPrivileged(KapuaSecurityUtils.java:110) at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.doGetAuthenticationInfo(UserPassAuthenticatingRealm.java:99) ... 40 common frames omitted Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160428-59c81c5): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*] b "; SQL statement: SET MODE MySQL://localhost:3306/kapuadb [42000-192] Error Code: 42000 at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:815) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303) at org.eclipse.kapua.commons.jpa.AbstractEntityManagerFactory.createEntityManager(AbstractEntityManagerFactory.java:96) at org.eclipse.kapua.commons.jpa.EntityManagerSession.internalOnResult(EntityManagerSession.java:138) ... 45 common frames omitted Caused by: org.eclipse.persistence.exceptions.DatabaseException: Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*] b "; SQL statement: SET MODE MySQL://localhost:3306/kapuadb [42000-192] Error Code: 42000 at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:326) at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:138) at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.setOrDetectDatasource(DatabaseSessionImpl.java:207) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:760) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:265) at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:731) ... 51 common frames omitted Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*] b "; SQL statement: SET MODE MySQL://localhost:3306/kapuadb [42000-192] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:179) at org.h2.message.DbException.get(DbException.java:155) at org.h2.message.DbException.getSyntaxError(DbException.java:191) at org.h2.command.Parser.getSyntaxError(Parser.java:530) at org.h2.command.Parser.prepareCommand(Parser.java:257) at org.h2.engine.Session.prepareLocal(Session.java:560) at org.h2.engine.Session.prepareCommand(Session.java:501) at org.h2.engine.Engine.openSession(Engine.java:203) at org.h2.engine.Engine.createSessionAndValidate(Engine.java:154) at org.h2.engine.Engine.createSession(Engine.java:137) at org.h2.engine.Engine.createSession(Engine.java:27) at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:349) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:118) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:102) at org.h2.Driver.connect(Driver.java:72) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:208) at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:98) ... 56 common frames omitted 05:09:38.795 [ActiveMQ NIO Worker 5] INFO o.e.k.b.c.p.KapuaSecurityBrokerFilter - User name kapua-sys - client id: ListenerClient, connection id: ID:hipp9-55172-1539075991412-5:58 05:09:38.797 [ActiveMQ NIO Worker 5] INFO eclipselink.logging.all - EclipseLink, version: Eclipse Persistence Services - 2.6.3.v20160428-59c81c5 05:09:38.798 [ActiveMQ NIO Worker 5] ERROR eclipselink.logging.ejb - Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160428-59c81c5): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*] b "; SQL statement: SET MODE MySQL://localhost:3306/kapuadb [42000-192] Error Code: 42000 05:09:38.800 [ActiveMQ NIO Worker 5] INFO o.e.k.b.c.p.KapuaSecurityBrokerFilter - @@ error org.eclipse.kapua.KapuaException: An internal error occurred: org.apache.shiro.ShiroException: Error while find user!. at org.eclipse.kapua.KapuaException.internalError(KapuaException.java:138) at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.handleTokenLoginException(AuthenticationServiceShiroImpl.java:358) at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.login(AuthenticationServiceShiroImpl.java:154) at org.eclipse.kapua.broker.core.plugin.KapuaSecurityBrokerFilter.addExternalConnection(KapuaSecurityBrokerFilter.java:412) at org.eclipse.kapua.broker.core.plugin.KapuaSecurityBrokerFilter.addConnection(KapuaSecurityBrokerFilter.java:395) at org.apache.activemq.broker.BrokerFilter.addConnection(BrokerFilter.java:98) at org.apache.activemq.broker.MutableBrokerFilter.addConnection(MutableBrokerFilter.java:103) at org.apache.activemq.broker.TransportConnection.processAddConnection(TransportConnection.java:852) at org.apache.activemq.command.ConnectionInfo.visit(ConnectionInfo.java:139) at org.apache.activemq.broker.TransportConnection.service(TransportConnection.java:336) at org.apache.activemq.broker.TransportConnection$1.onCommand(TransportConnection.java:200) at org.apache.activemq.transport.MutexTransport.onCommand(MutexTransport.java:45) at org.apache.activemq.transport.mqtt.MQTTInactivityMonitor.onCommand(MQTTInactivityMonitor.java:162) at org.apache.activemq.transport.mqtt.MQTTTransportFilter.sendToActiveMQ(MQTTTransportFilter.java:106) at org.apache.activemq.transport.mqtt.MQTTProtocolConverter.sendToActiveMQ(MQTTProtocolConverter.java:181) at org.apache.activemq.transport.mqtt.MQTTProtocolConverter.onMQTTConnect(MQTTProtocolConverter.java:310) at org.apache.activemq.transport.mqtt.MQTTProtocolConverter.onMQTTCommand(MQTTProtocolConverter.java:205) at org.apache.activemq.transport.mqtt.MQTTTransportFilter.onCommand(MQTTTransportFilter.java:94) at org.apache.activemq.transport.TransportSupport.doConsume(TransportSupport.java:83) at org.apache.activemq.transport.mqtt.MQTTCodec$1.onFrame(MQTTCodec.java:65) at org.apache.activemq.transport.mqtt.MQTTCodec.processCommand(MQTTCodec.java:90) at org.apache.activemq.transport.mqtt.MQTTCodec.access$400(MQTTCodec.java:26) at org.apache.activemq.transport.mqtt.MQTTCodec$4.parse(MQTTCodec.java:213) at org.apache.activemq.transport.mqtt.MQTTCodec$3.parse(MQTTCodec.java:179) at org.apache.activemq.transport.mqtt.MQTTCodec$2.parse(MQTTCodec.java:138) at org.apache.activemq.transport.mqtt.MQTTCodec.parse(MQTTCodec.java:76) at org.apache.activemq.transport.mqtt.MQTTNIOTransport.processBuffer(MQTTNIOTransport.java:132) at org.apache.activemq.transport.mqtt.MQTTNIOTransport.serviceRead(MQTTNIOTransport.java:120) at org.apache.activemq.transport.mqtt.MQTTNIOTransport.access$000(MQTTNIOTransport.java:43) at org.apache.activemq.transport.mqtt.MQTTNIOTransport$1.onSelect(MQTTNIOTransport.java:72) at org.apache.activemq.transport.nio.SelectorSelection.onSelect(SelectorSelection.java:98) at org.apache.activemq.transport.nio.SelectorWorker$1.run(SelectorWorker.java:118) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: org.apache.shiro.authc.AuthenticationException: org.apache.shiro.ShiroException: Error while find user! at org.eclipse.kapua.service.authentication.shiro.KapuaAuthenticator.doMultiRealmAuthentication(KapuaAuthenticator.java:85) at org.apache.shiro.authc.pam.ModularRealmAuthenticator.doAuthenticate(ModularRealmAuthenticator.java:269) at org.apache.shiro.authc.AbstractAuthenticator.authenticate(AbstractAuthenticator.java:198) at org.apache.shiro.mgt.AuthenticatingSecurityManager.authenticate(AuthenticatingSecurityManager.java:106) at org.apache.shiro.mgt.DefaultSecurityManager.login(DefaultSecurityManager.java:270) at org.apache.shiro.subject.support.DelegatingSubject.login(DelegatingSubject.java:256) at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.login(AuthenticationServiceShiroImpl.java:138) ... 32 common frames omitted Caused by: org.apache.shiro.ShiroException: Error while find user! at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.doGetAuthenticationInfo(UserPassAuthenticatingRealm.java:103) at org.apache.shiro.realm.AuthenticatingRealm.getAuthenticationInfo(AuthenticatingRealm.java:568) at org.eclipse.kapua.service.authentication.shiro.KapuaAuthenticator.doMultiRealmAuthentication(KapuaAuthenticator.java:58) ... 38 common frames omitted Caused by: org.eclipse.kapua.KapuaException: An internal error occurred: Error during Persistence Operation. at org.eclipse.kapua.KapuaException.internalError(KapuaException.java:123) at org.eclipse.kapua.commons.util.KapuaExceptionUtils.convertPersistenceException(KapuaExceptionUtils.java:113) at org.eclipse.kapua.commons.jpa.EntityManagerSession.internalOnResult(EntityManagerSession.java:152) at org.eclipse.kapua.commons.jpa.EntityManagerSession.onResult(EntityManagerSession.java:118) at org.eclipse.kapua.service.user.internal.UserServiceImpl.findByName(UserServiceImpl.java:228) at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.lambda$doGetAuthenticationInfo$0(UserPassAuthenticatingRealm.java:99) at org.eclipse.kapua.commons.security.KapuaSecurityUtils.doPrivileged(KapuaSecurityUtils.java:110) at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.doGetAuthenticationInfo(UserPassAuthenticatingRealm.java:99) ... 40 common frames omitted Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160428-59c81c5): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*] b "; SQL statement: SET MODE MySQL://localhost:3306/kapuadb [42000-192] Error Code: 42000 at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:815) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303) at org.eclipse.kapua.commons.jpa.AbstractEntityManagerFactory.createEntityManager(AbstractEntityManagerFactory.java:96) at org.eclipse.kapua.commons.jpa.EntityManagerSession.internalOnResult(EntityManagerSession.java:138) ... 45 common frames omitted Caused by: org.eclipse.persistence.exceptions.DatabaseException: Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*] b "; SQL statement: SET MODE MySQL://localhost:3306/kapuadb [42000-192] Error Code: 42000 at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:326) at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:138) at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.setOrDetectDatasource(DatabaseSessionImpl.java:207) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:760) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:265) at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:731) ... 51 common frames omitted Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*] b "; SQL statement: SET MODE MySQL://localhost:3306/kapuadb [42000-192] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:179) at org.h2.message.DbException.get(DbException.java:155) at org.h2.message.DbException.getSyntaxError(DbException.java:191) at org.h2.command.Parser.getSyntaxError(Parser.java:530) at org.h2.command.Parser.prepareCommand(Parser.java:257) at org.h2.engine.Session.prepareLocal(Session.java:560) at org.h2.engine.Session.prepareCommand(Session.java:501) at org.h2.engine.Engine.openSession(Engine.java:203) at org.h2.engine.Engine.createSessionAndValidate(Engine.java:154) at org.h2.engine.Engine.createSession(Engine.java:137) at org.h2.engine.Engine.createSession(Engine.java:27) at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:349) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:118) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:102) at org.h2.Driver.connect(Driver.java:72) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:208) at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:98) ... 56 common frames omitted 05:09:38.800 [ActiveMQ NIO Worker 5] WARN o.a.a.broker.TransportConnection - Failed to add Connection id=ID:hipp9-55172-1539075991412-5:58, clientId=ListenerClient due to {} org.eclipse.kapua.KapuaException: An internal error occurred: org.apache.shiro.ShiroException: Error while find user!. at org.eclipse.kapua.KapuaException.internalError(KapuaException.java:138) at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.handleTokenLoginException(AuthenticationServiceShiroImpl.java:358) at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.login(AuthenticationServiceShiroImpl.java:154) at org.eclipse.kapua.broker.core.plugin.KapuaSecurityBrokerFilter.addExternalConnection(KapuaSecurityBrokerFilter.java:412) at org.eclipse.kapua.broker.core.plugin.KapuaSecurityBrokerFilter.addConnection(KapuaSecurityBrokerFilter.java:395) at org.apache.activemq.broker.BrokerFilter.addConnection(BrokerFilter.java:98) at org.apache.activemq.broker.MutableBrokerFilter.addConnection(MutableBrokerFilter.java:103) at org.apache.activemq.broker.TransportConnection.processAddConnection(TransportConnection.java:852) at org.apache.activemq.command.ConnectionInfo.visit(ConnectionInfo.java:139) at org.apache.activemq.broker.TransportConnection.service(TransportConnection.java:336) at org.apache.activemq.broker.TransportConnection$1.onCommand(TransportConnection.java:200) at org.apache.activemq.transport.MutexTransport.onCommand(MutexTransport.java:45) at org.apache.activemq.transport.mqtt.MQTTInactivityMonitor.onCommand(MQTTInactivityMonitor.java:162) at org.apache.activemq.transport.mqtt.MQTTTransportFilter.sendToActiveMQ(MQTTTransportFilter.java:106) at org.apache.activemq.transport.mqtt.MQTTProtocolConverter.sendToActiveMQ(MQTTProtocolConverter.java:181) at org.apache.activemq.transport.mqtt.MQTTProtocolConverter.onMQTTConnect(MQTTProtocolConverter.java:310) at org.apache.activemq.transport.mqtt.MQTTProtocolConverter.onMQTTCommand(MQTTProtocolConverter.java:205) at org.apache.activemq.transport.mqtt.MQTTTransportFilter.onCommand(MQTTTransportFilter.java:94) at org.apache.activemq.transport.TransportSupport.doConsume(TransportSupport.java:83) at org.apache.activemq.transport.mqtt.MQTTCodec$1.onFrame(MQTTCodec.java:65) at org.apache.activemq.transport.mqtt.MQTTCodec.processCommand(MQTTCodec.java:90) at org.apache.activemq.transport.mqtt.MQTTCodec.access$400(MQTTCodec.java:26) at org.apache.activemq.transport.mqtt.MQTTCodec$4.parse(MQTTCodec.java:213) at org.apache.activemq.transport.mqtt.MQTTCodec$3.parse(MQTTCodec.java:179) at org.apache.activemq.transport.mqtt.MQTTCodec$2.parse(MQTTCodec.java:138) at org.apache.activemq.transport.mqtt.MQTTCodec.parse(MQTTCodec.java:76) at org.apache.activemq.transport.mqtt.MQTTNIOTransport.processBuffer(MQTTNIOTransport.java:132) at org.apache.activemq.transport.mqtt.MQTTNIOTransport.serviceRead(MQTTNIOTransport.java:120) at org.apache.activemq.transport.mqtt.MQTTNIOTransport.access$000(MQTTNIOTransport.java:43) at org.apache.activemq.transport.mqtt.MQTTNIOTransport$1.onSelect(MQTTNIOTransport.java:72) at org.apache.activemq.transport.nio.SelectorSelection.onSelect(SelectorSelection.java:98) at org.apache.activemq.transport.nio.SelectorWorker$1.run(SelectorWorker.java:118) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: org.apache.shiro.authc.AuthenticationException: org.apache.shiro.ShiroException: Error while find user! at org.eclipse.kapua.service.authentication.shiro.KapuaAuthenticator.doMultiRealmAuthentication(KapuaAuthenticator.java:85) at org.apache.shiro.authc.pam.ModularRealmAuthenticator.doAuthenticate(ModularRealmAuthenticator.java:269) at org.apache.shiro.authc.AbstractAuthenticator.authenticate(AbstractAuthenticator.java:198) at org.apache.shiro.mgt.AuthenticatingSecurityManager.authenticate(AuthenticatingSecurityManager.java:106) at org.apache.shiro.mgt.DefaultSecurityManager.login(DefaultSecurityManager.java:270) at org.apache.shiro.subject.support.DelegatingSubject.login(DelegatingSubject.java:256) at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.login(AuthenticationServiceShiroImpl.java:138) ... 32 common frames omitted Caused by: org.apache.shiro.ShiroException: Error while find user! at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.doGetAuthenticationInfo(UserPassAuthenticatingRealm.java:103) at org.apache.shiro.realm.AuthenticatingRealm.getAuthenticationInfo(AuthenticatingRealm.java:568) at org.eclipse.kapua.service.authentication.shiro.KapuaAuthenticator.doMultiRealmAuthentication(KapuaAuthenticator.java:58) ... 38 common frames omitted Caused by: org.eclipse.kapua.KapuaException: An internal error occurred: Error during Persistence Operation. at org.eclipse.kapua.KapuaException.internalError(KapuaException.java:123) at org.eclipse.kapua.commons.util.KapuaExceptionUtils.convertPersistenceException(KapuaExceptionUtils.java:113) at org.eclipse.kapua.commons.jpa.EntityManagerSession.internalOnResult(EntityManagerSession.java:152) at org.eclipse.kapua.commons.jpa.EntityManagerSession.onResult(EntityManagerSession.java:118) at org.eclipse.kapua.service.user.internal.UserServiceImpl.findByName(UserServiceImpl.java:228) at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.lambda$doGetAuthenticationInfo$0(UserPassAuthenticatingRealm.java:99) at org.eclipse.kapua.commons.security.KapuaSecurityUtils.doPrivileged(KapuaSecurityUtils.java:110) at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.doGetAuthenticationInfo(UserPassAuthenticatingRealm.java:99) ... 40 common frames omitted Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160428-59c81c5): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*] b "; SQL statement: SET MODE MySQL://localhost:3306/kapuadb [42000-192] Error Code: 42000 at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:815) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303) at org.eclipse.kapua.commons.jpa.AbstractEntityManagerFactory.createEntityManager(AbstractEntityManagerFactory.java:96) at org.eclipse.kapua.commons.jpa.EntityManagerSession.internalOnResult(EntityManagerSession.java:138) ... 45 common frames omitted Caused by: org.eclipse.persistence.exceptions.DatabaseException: Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*] b "; SQL statement: SET MODE MySQL://localhost:3306/kapuadb [42000-192] Error Code: 42000 at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:326) at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:138) at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.setOrDetectDatasource(DatabaseSessionImpl.java:207) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:760) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:265) at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:731) ... 51 common frames omitted Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*] b "; SQL statement: SET MODE MySQL://localhost:3306/kapuadb [42000-192] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:179) at org.h2.message.DbException.get(DbException.java:155) at org.h2.message.DbException.getSyntaxError(DbException.java:191) at org.h2.command.Parser.getSyntaxError(Parser.java:530) at org.h2.command.Parser.prepareCommand(Parser.java:257) at org.h2.engine.Session.prepareLocal(Session.java:560) at org.h2.engine.Session.prepareCommand(Session.java:501) at org.h2.engine.Engine.openSession(Engine.java:203) at org.h2.engine.Engine.createSessionAndValidate(Engine.java:154) at org.h2.engine.Engine.createSession(Engine.java:137) at org.h2.engine.Engine.createSession(Engine.java:27) at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:349) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:118) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:102) at org.h2.Driver.connect(Driver.java:72) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:208) at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:98) ... 56 common frames omitted 05:09:40.790 [ActiveMQ BrokerService[message-broker] Task-1] INFO o.a.a.broker.TransportConnection - Stopping tcp://127.0.0.1:60109 because Failed with SecurityException: An internal error occurred: org.apache.shiro.ShiroException: Error while find user!. 05:09:40.802 [ActiveMQ BrokerService[message-broker] Task-3] INFO o.a.a.broker.TransportConnection - Stopping tcp://127.0.0.1:60110 because Failed with SecurityException: An internal error occurred: org.apache.shiro.ShiroException: Error while find user!. 05:09:43.806 [main] INFO eclipselink.logging.all - EclipseLink, version: Eclipse Persistence Services - 2.6.3.v20160428-59c81c5 05:09:43.807 [main] ERROR eclipselink.logging.ejb - Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160428-59c81c5): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*] b "; SQL statement: SET MODE MySQL://localhost:3306/kapuadb [42000-192] Error Code: 42000
Standard Error
Broker unavailable (3) at org.eclipse.paho.client.mqttv3.internal.ExceptionHelper.createMqttException(ExceptionHelper.java:31) at org.eclipse.paho.client.mqttv3.internal.ClientState.notifyReceivedAck(ClientState.java:990) at org.eclipse.paho.client.mqttv3.internal.CommsReceiver.run(CommsReceiver.java:118) at java.lang.Thread.run(Thread.java:748)